<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> 
<html xmlns="http://www.w3.org/1999/xhtml"> 
<head> 
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> 
<title>DBdoc</title> 
</head> 
<style type="text/css"> 
	table {width: 100%; border-collapse: collapse;} 
	table, td, th {border: 1px solid black;} 
</style> 
<body> 
<h1>mydb</h1> 
<ol> 
</ol> 
<ol> 
<h1>db20120317</h1> 
<ol> 
<li><a href="#alunos">alunos</a> (22 campos)</li><li><a href="#bairros">bairros</a> (6 campos)</li><li><a href="#cidades">cidades</a> (8 campos)</li><li><a href="#cursos">cursos</a> (16 campos)</li><li><a href="#cursos_turmas">cursos_turmas</a> (2 campos)</li><li><a href="#estado_civil">estado_civil</a> (5 campos)</li><li><a href="#estados">estados</a> (7 campos)</li><li><a href="#logradouros">logradouros</a> (6 campos)</li><li><a href="#members">members</a> (37 campos)</li><li><a href="#members_offices">members_offices</a> (3 campos)</li><li><a href="#menu">menu</a> (8 campos)</li><li><a href="#menu_profiles">menu_profiles</a> (2 campos)</li><li><a href="#midia">midia</a> (5 campos)</li><li><a href="#paises">paises</a> (8 campos)</li><li><a href="#profiles">profiles</a> (5 campos)</li><li><a href="#profissoes">profissoes</a> (6 campos)</li><li><a href="#turmas">turmas</a> (14 campos)</li><li><a href="#unidade">unidade</a> (11 campos)</li><li><a href="#unidade_curso">unidade_curso</a> (2 campos)</li><li><a href="#offices">offices</a> (1 campos)</li><li><a href="#Disciplinas">Disciplinas</a> (10 campos)</li><li><a href="#Departamentos">Departamentos</a> (4 campos)</li><li><a href="#disciplina_curso">disciplina_curso</a> (2 campos)</li><li><a href="#Cargos">Cargos</a> (5 campos)</li><li><a href="#disciplina_member">disciplina_member</a> (2 campos)</li></ol> 
<ol> 
<li id="alunos"> 
<h2>alunos</h2> 
<p>Informações dos alunos.</p> 
<table> 
<tr> 
<th>CAMPO</th> 
<th>TIPO</th> 
<th>NULO</th> 
<th>EXTRA</th> 
<th>COMENTARIOS</th> 
</tr> 
<tr> 
   <td>idAluno</td> 
   <td>INT(11)</td> 
    <td>NO</td> 
    <td>AUTO_INCREMENT</td> 
    <td></td> 
</tr> 
<tr> 
   <td>idTurma</td> 
   <td>INT(11)</td> 
    <td>NO</td> 
    <td> - </td> 
    <td></td> 
</tr> 
<tr> 
   <td>idEstadoCivil</td> 
   <td>INT(11)</td> 
    <td>NO</td> 
    <td> - </td> 
    <td></td> 
</tr> 
<tr> 
   <td>ds_cep</td> 
   <td>INT(11)</td> 
    <td>NO</td> 
    <td> - </td> 
    <td></td> 
</tr> 
<tr> 
   <td>ds_matricula</td> 
   <td>INT(15)</td> 
    <td>NO</td> 
    <td> - </td> 
    <td></td> 
</tr> 
<tr> 
   <td>ds_nome</td> 
   <td>VARCHAR(120)</td> 
    <td>NO</td> 
    <td> - </td> 
    <td></td> 
</tr> 
<tr> 
   <td>dt_nascimento</td> 
   <td>DATE</td> 
    <td>NO</td> 
    <td> - </td> 
    <td></td> 
</tr> 
<tr> 
   <td>ds_sexo</td> 
   <td>CHAR(1)</td> 
    <td>NO</td> 
    <td> - </td> 
    <td></td> 
</tr> 
<tr> 
   <td>ds_responsavel</td> 
   <td>VARCHAR(120)</td> 
    <td>SI</td> 
    <td> - </td> 
    <td></td> 
</tr> 
<tr> 
   <td>ds_cpf</td> 
   <td>VARCHAR(14)</td> 
    <td>NO</td> 
    <td> - </td> 
    <td></td> 
</tr> 
<tr> 
   <td>ds_rg</td> 
   <td>VARCHAR(20)</td> 
    <td>NO</td> 
    <td> - </td> 
    <td></td> 
</tr> 
<tr> 
   <td>ds_email</td> 
   <td>VARCHAR(180)</td> 
    <td>SI</td> 
    <td> - </td> 
    <td></td> 
</tr> 
<tr> 
   <td>ds_pai</td> 
   <td>VARCHAR(120)</td> 
    <td>SI</td> 
    <td> - </td> 
    <td></td> 
</tr> 
<tr> 
   <td>ds_mae</td> 
   <td>VARCHAR(120)</td> 
    <td>NO</td> 
    <td> - </td> 
    <td></td> 
</tr> 
<tr> 
   <td>id_profissao</td> 
   <td>INT(11)</td> 
    <td>SI</td> 
    <td> - </td> 
    <td></td> 
</tr> 
<tr> 
   <td>idMidia</td> 
   <td>INT(11)</td> 
    <td>NO</td> 
    <td> - </td> 
    <td></td> 
</tr> 
<tr> 
   <td>idIndicacao</td> 
   <td>INT(11)</td> 
    <td>SI</td> 
    <td> - </td> 
    <td></td> 
</tr> 
<tr> 
   <td>idContato</td> 
   <td>INT(11)</td> 
    <td>SI</td> 
    <td> - </td> 
    <td></td> 
</tr> 
<tr> 
   <td>dt_cadastro</td> 
   <td>DATETIME</td> 
    <td>NO</td> 
    <td> - </td> 
    <td></td> 
</tr> 
<tr> 
   <td>dt_atualizacao</td> 
   <td>DATETIME</td> 
    <td>SI</td> 
    <td> - </td> 
    <td></td> 
</tr> 
<tr> 
   <td>idMember</td> 
   <td>INT(11)</td> 
    <td>NO</td> 
    <td> - </td> 
    <td></td> 
</tr> 
<tr> 
   <td>st_aluno</td> 
   <td>TINYINT(11)</td> 
    <td>NO</td> 
    <td> - </td> 
    <td></td> 
</tr> 
</table> 
</li> 
<li id="bairros"> 
<h2>bairros</h2> 
<p></p> 
<table> 
<tr> 
<th>CAMPO</th> 
<th>TIPO</th> 
<th>NULO</th> 
<th>EXTRA</th> 
<th>COMENTARIOS</th> 
</tr> 
<tr> 
   <td>idBairro</td> 
   <td>INT(11)</td> 
    <td>NO</td> 
    <td>AUTO_INCREMENT</td> 
    <td></td> 
</tr> 
<tr> 
   <td>ds_bairro</td> 
   <td>VARCHAR(120)</td> 
    <td>NO</td> 
    <td> - </td> 
    <td></td> 
</tr> 
<tr> 
   <td>st_bairro</td> 
   <td>TINYINT(1)</td> 
    <td>NO</td> 
    <td> - </td> 
    <td></td> 
</tr> 
<tr> 
   <td>dt_insercao</td> 
   <td>DATETIME</td> 
    <td>NO</td> 
    <td> - </td> 
    <td></td> 
</tr> 
<tr> 
   <td>dt_atualizacao</td> 
   <td>DATETIME</td> 
    <td>SI</td> 
    <td> - </td> 
    <td></td> 
</tr> 
<tr> 
   <td>idCidade</td> 
   <td>INT(11)</td> 
    <td>NO</td> 
    <td> - </td> 
    <td></td> 
</tr> 
</table> 
</li> 
<li id="cidades"> 
<h2>cidades</h2> 
<p></p> 
<table> 
<tr> 
<th>CAMPO</th> 
<th>TIPO</th> 
<th>NULO</th> 
<th>EXTRA</th> 
<th>COMENTARIOS</th> 
</tr> 
<tr> 
   <td>idCidade</td> 
   <td>INT(11)</td> 
    <td>NO</td> 
    <td>AUTO_INCREMENT</td> 
    <td></td> 
</tr> 
<tr> 
   <td>ds_cidade</td> 
   <td>VARCHAR(120)</td> 
    <td>NO</td> 
    <td> - </td> 
    <td></td> 
</tr> 
<tr> 
   <td>nr_cod_area</td> 
   <td>INT(11)</td> 
    <td>NO</td> 
    <td> - </td> 
    <td></td> 
</tr> 
<tr> 
   <td>sgl_cidade</td> 
   <td>VARCHAR(5)</td> 
    <td>SI</td> 
    <td> - </td> 
    <td></td> 
</tr> 
<tr> 
   <td>st_cidade</td> 
   <td>TINYINT(1)</td> 
    <td>NO</td> 
    <td> - </td> 
    <td></td> 
</tr> 
<tr> 
   <td>dt_insercao</td> 
   <td>DATETIME</td> 
    <td>NO</td> 
    <td> - </td> 
    <td></td> 
</tr> 
<tr> 
   <td>dt_atualizacao</td> 
   <td>DATETIME</td> 
    <td>SI</td> 
    <td> - </td> 
    <td></td> 
</tr> 
<tr> 
   <td>idEstado</td> 
   <td>INT(11)</td> 
    <td>NO</td> 
    <td> - </td> 
    <td></td> 
</tr> 
</table> 
</li> 
<li id="cursos"> 
<h2>cursos</h2> 
<p></p> 
<table> 
<tr> 
<th>CAMPO</th> 
<th>TIPO</th> 
<th>NULO</th> 
<th>EXTRA</th> 
<th>COMENTARIOS</th> 
</tr> 
<tr> 
   <td>idCurso</td> 
   <td>INT(11)</td> 
    <td>NO</td> 
    <td>AUTO_INCREMENT</td> 
    <td></td> 
</tr> 
<tr> 
   <td>sgl_curso</td> 
   <td>VARCHAR(10)</td> 
    <td>NO</td> 
    <td> - </td> 
    <td></td> 
</tr> 
<tr> 
   <td>ds_curso</td> 
   <td>VARCHAR(120)</td> 
    <td>NO</td> 
    <td> - </td> 
    <td></td> 
</tr> 
<tr> 
   <td>ds_precondicao</td> 
   <td>VARCHAR(200)</td> 
    <td>SI</td> 
    <td> - </td> 
    <td></td> 
</tr> 
<tr> 
   <td>ds_poscondicao</td> 
   <td>VARCHAR(200)</td> 
    <td>SI</td> 
    <td> - </td> 
    <td></td> 
</tr> 
<tr> 
   <td>idPeriodo</td> 
   <td>INT(11)</td> 
    <td>NO</td> 
    <td> - </td> 
    <td></td> 
</tr> 
<tr> 
   <td>idDepartamento</td> 
   <td>INT(11)</td> 
    <td>NO</td> 
    <td> - </td> 
    <td></td> 
</tr> 
<tr> 
   <td>idTipoCurso</td> 
   <td>INT(11)</td> 
    <td>NO</td> 
    <td> - </td> 
    <td></td> 
</tr> 
<tr> 
   <td>idCoordenador</td> 
   <td>INT(11)</td> 
    <td>NO</td> 
    <td> - </td> 
    <td></td> 
</tr> 
<tr> 
   <td>ds_carga_horaria</td> 
   <td>INT(11)</td> 
    <td>NO</td> 
    <td> - </td> 
    <td></td> 
</tr> 
<tr> 
   <td>st_curso</td> 
   <td>TINYINT(1)</td> 
    <td>NO</td> 
    <td> - </td> 
    <td></td> 
</tr> 
<tr> 
   <td>dt_insercao</td> 
   <td>DATETIME</td> 
    <td>NO</td> 
    <td> - </td> 
    <td></td> 
</tr> 
<tr> 
   <td>dt_atualizacao</td> 
   <td>DATETIME</td> 
    <td>SI</td> 
    <td> - </td> 
    <td></td> 
</tr> 
<tr> 
   <td>ds_objetivo</td> 
   <td>TEXT</td> 
    <td>NO</td> 
    <td> - </td> 
    <td></td> 
</tr> 
<tr> 
   <td>ds_conteudo</td> 
   <td>TEXT</td> 
    <td>NO</td> 
    <td> - </td> 
    <td></td> 
</tr> 
<tr> 
   <td>ds_metodologia</td> 
   <td>TEXT</td> 
    <td>NO</td> 
    <td> - </td> 
    <td></td> 
</tr> 
</table> 
</li> 
<li id="cursos_turmas"> 
<h2>cursos_turmas</h2> 
<p></p> 
<table> 
<tr> 
<th>CAMPO</th> 
<th>TIPO</th> 
<th>NULO</th> 
<th>EXTRA</th> 
<th>COMENTARIOS</th> 
</tr> 
<tr> 
   <td>idCurso</td> 
   <td>INT(11)</td> 
    <td>NO</td> 
    <td> - </td> 
    <td></td> 
</tr> 
<tr> 
   <td>idTurma</td> 
   <td>INT(11)</td> 
    <td>NO</td> 
    <td> - </td> 
    <td></td> 
</tr> 
</table> 
</li> 
<li id="estado_civil"> 
<h2>estado_civil</h2> 
<p>Informações de Estado Civil	</p> 
<table> 
<tr> 
<th>CAMPO</th> 
<th>TIPO</th> 
<th>NULO</th> 
<th>EXTRA</th> 
<th>COMENTARIOS</th> 
</tr> 
<tr> 
   <td>idEstadoCivil</td> 
   <td>INT(11)</td> 
    <td>NO</td> 
    <td>AUTO_INCREMENT</td> 
    <td></td> 
</tr> 
<tr> 
   <td>ds_estado_civil</td> 
   <td>VARCHAR(120)</td> 
    <td>NO</td> 
    <td> - </td> 
    <td></td> 
</tr> 
<tr> 
   <td>st_estado_civil</td> 
   <td>TINYINT(4)</td> 
    <td>NO</td> 
    <td> - </td> 
    <td></td> 
</tr> 
<tr> 
   <td>dt_insercao</td> 
   <td>DATETIME</td> 
    <td>NO</td> 
    <td> - </td> 
    <td></td> 
</tr> 
<tr> 
   <td>dt_atualizacao</td> 
   <td>DATETIME</td> 
    <td>SI</td> 
    <td> - </td> 
    <td></td> 
</tr> 
</table> 
</li> 
<li id="estados"> 
<h2>estados</h2> 
<p></p> 
<table> 
<tr> 
<th>CAMPO</th> 
<th>TIPO</th> 
<th>NULO</th> 
<th>EXTRA</th> 
<th>COMENTARIOS</th> 
</tr> 
<tr> 
   <td>idEstado</td> 
   <td>INT(11)</td> 
    <td>NO</td> 
    <td>AUTO_INCREMENT</td> 
    <td></td> 
</tr> 
<tr> 
   <td>sgl_estado</td> 
   <td>CHAR(2)</td> 
    <td>NO</td> 
    <td> - </td> 
    <td></td> 
</tr> 
<tr> 
   <td>ds_estado</td> 
   <td>VARCHAR(120)</td> 
    <td>NO</td> 
    <td> - </td> 
    <td></td> 
</tr> 
<tr> 
   <td>idPais</td> 
   <td>INT(11)</td> 
    <td>NO</td> 
    <td> - </td> 
    <td></td> 
</tr> 
<tr> 
   <td>st_estado</td> 
   <td>TINYINT(1)</td> 
    <td>NO</td> 
    <td> - </td> 
    <td></td> 
</tr> 
<tr> 
   <td>dt_insercao</td> 
   <td>DATETIME</td> 
    <td>NO</td> 
    <td> - </td> 
    <td></td> 
</tr> 
<tr> 
   <td>dt_atualizacao</td> 
   <td>DATETIME</td> 
    <td>SI</td> 
    <td> - </td> 
    <td></td> 
</tr> 
</table> 
</li> 
<li id="logradouros"> 
<h2>logradouros</h2> 
<p></p> 
<table> 
<tr> 
<th>CAMPO</th> 
<th>TIPO</th> 
<th>NULO</th> 
<th>EXTRA</th> 
<th>COMENTARIOS</th> 
</tr> 
<tr> 
   <td>ds_cep</td> 
   <td>INT(11)</td> 
    <td>NO</td> 
    <td> - </td> 
    <td></td> 
</tr> 
<tr> 
   <td>ds_logradouro</td> 
   <td>VARCHAR(20)</td> 
    <td>NO</td> 
    <td> - </td> 
    <td></td> 
</tr> 
<tr> 
   <td>st_lograduro</td> 
   <td>TINYINT(4)</td> 
    <td>NO</td> 
    <td> - </td> 
    <td></td> 
</tr> 
<tr> 
   <td>dt_insercao</td> 
   <td>DATETIME</td> 
    <td>NO</td> 
    <td> - </td> 
    <td></td> 
</tr> 
<tr> 
   <td>dt_atualizacao</td> 
   <td>DATETIME</td> 
    <td>SI</td> 
    <td> - </td> 
    <td></td> 
</tr> 
<tr> 
   <td>idBairro</td> 
   <td>INT(11)</td> 
    <td>NO</td> 
    <td> - </td> 
    <td></td> 
</tr> 
</table> 
</li> 
<li id="members"> 
<h2>members</h2> 
<p></p> 
<table> 
<tr> 
<th>CAMPO</th> 
<th>TIPO</th> 
<th>NULO</th> 
<th>EXTRA</th> 
<th>COMENTARIOS</th> 
</tr> 
<tr> 
   <td>idMember</td> 
   <td>INT(11)</td> 
    <td>NO</td> 
    <td>AUTO_INCREMENT</td> 
    <td></td> 
</tr> 
<tr> 
   <td>ds_member</td> 
   <td>VARCHAR(100)</td> 
    <td>NO</td> 
    <td> - </td> 
    <td></td> 
</tr> 
<tr> 
   <td>idCep</td> 
   <td>INT(11)</td> 
    <td>NO</td> 
    <td> - </td> 
    <td></td> 
</tr> 
<tr> 
   <td>nr_residencial</td> 
   <td>VARCHAR(20)</td> 
    <td>NO</td> 
    <td> - </td> 
    <td></td> 
</tr> 
<tr> 
   <td>ds_complemento_residencial</td> 
   <td>VARCHAR(100)</td> 
    <td>SI</td> 
    <td> - </td> 
    <td></td> 
</tr> 
<tr> 
   <td>ds_fone_residencial</td> 
   <td>VARCHAR(30)</td> 
    <td>SI</td> 
    <td> - </td> 
    <td></td> 
</tr> 
<tr> 
   <td>ds_fone_cel</td> 
   <td>VARCHAR(30)</td> 
    <td>SI</td> 
    <td> - </td> 
    <td></td> 
</tr> 
<tr> 
   <td>ds_fone_contato</td> 
   <td>VARCHAR(30)</td> 
    <td>SI</td> 
    <td> - </td> 
    <td></td> 
</tr> 
<tr> 
   <td>ds_sex</td> 
   <td>CHAR(1)</td> 
    <td>NO</td> 
    <td> - </td> 
    <td></td> 
</tr> 
<tr> 
   <td>dt_nascimento</td> 
   <td>DATE</td> 
    <td>NO</td> 
    <td> - </td> 
    <td></td> 
</tr> 
<tr> 
   <td>idEstadoCivil</td> 
   <td>INT(11)</td> 
    <td>NO</td> 
    <td> - </td> 
    <td></td> 
</tr> 
<tr> 
   <td>ds_email</td> 
   <td>VARCHAR(100)</td> 
    <td>SI</td> 
    <td> - </td> 
    <td></td> 
</tr> 
<tr> 
   <td>ds_rg</td> 
   <td>VARCHAR(32)</td> 
    <td>NO</td> 
    <td> - </td> 
    <td></td> 
</tr> 
<tr> 
   <td>ds_cpf</td> 
   <td>VARCHAR(14)</td> 
    <td>NO</td> 
    <td> - </td> 
    <td></td> 
</tr> 
<tr> 
   <td>ds_carteira_profissional</td> 
   <td>VARCHAR(100)</td> 
    <td>NO</td> 
    <td> - </td> 
    <td></td> 
</tr> 
<tr> 
   <td>ds_inss</td> 
   <td>VARCHAR(100)</td> 
    <td>NO</td> 
    <td> - </td> 
    <td></td> 
</tr> 
<tr> 
   <td>ds_titulo_eleitor</td> 
   <td>VARCHAR(100)</td> 
    <td>NO</td> 
    <td> - </td> 
    <td></td> 
</tr> 
<tr> 
   <td>ds_cnh</td> 
   <td>VARCHAR(100)</td> 
    <td>SI</td> 
    <td> - </td> 
    <td></td> 
</tr> 
<tr> 
   <td>ds_cnh_tipo</td> 
   <td>VARCHAR(10)</td> 
    <td>SI</td> 
    <td> - </td> 
    <td></td> 
</tr> 
<tr> 
   <td>ds_photo</td> 
   <td>VARCHAR(256)</td> 
    <td>SI</td> 
    <td> - </td> 
    <td></td> 
</tr> 
<tr> 
   <td>dt_admissao</td> 
   <td>DATE</td> 
    <td>NO</td> 
    <td> - </td> 
    <td></td> 
</tr> 
<tr> 
   <td>hr_inicial_atividades</td> 
   <td>TIME</td> 
    <td>NO</td> 
    <td> - </td> 
    <td></td> 
</tr> 
<tr> 
   <td>hr_final_atividades</td> 
   <td>TIME</td> 
    <td>NO</td> 
    <td> - </td> 
    <td></td> 
</tr> 
<tr> 
   <td>ds_login</td> 
   <td>VARCHAR(32)</td> 
    <td>SI</td> 
    <td> - </td> 
    <td></td> 
</tr> 
<tr> 
   <td>ds_password</td> 
   <td>VARCHAR(32)</td> 
    <td>SI</td> 
    <td> - </td> 
    <td></td> 
</tr> 
<tr> 
   <td>ds_password_temporary</td> 
   <td>VARCHAR(32)</td> 
    <td>SI</td> 
    <td> - </td> 
    <td></td> 
</tr> 
<tr> 
   <td>idProfile</td> 
   <td>INT(11)</td> 
    <td>SI</td> 
    <td> - </td> 
    <td></td> 
</tr> 
<tr> 
   <td>idDepartamento</td> 
   <td>INT(11)</td> 
    <td>NO</td> 
    <td> - </td> 
    <td></td> 
</tr> 
<tr> 
   <td>dt_created</td> 
   <td>DATETIME</td> 
    <td>NO</td> 
    <td> - </td> 
    <td></td> 
</tr> 
<tr> 
   <td>dt_updated</td> 
   <td>DATETIME</td> 
    <td>SI</td> 
    <td> - </td> 
    <td></td> 
</tr> 
<tr> 
   <td>dt_first_login</td> 
   <td>DATETIME</td> 
    <td>SI</td> 
    <td> - </td> 
    <td></td> 
</tr> 
<tr> 
   <td>dt_current_login</td> 
   <td>DATETIME</td> 
    <td>SI</td> 
    <td> - </td> 
    <td></td> 
</tr> 
<tr> 
   <td>dt_last_login</td> 
   <td>DATETIME</td> 
    <td>SI</td> 
    <td> - </td> 
    <td></td> 
</tr> 
<tr> 
   <td>dt_last_logout</td> 
   <td>DATETIME</td> 
    <td>SI</td> 
    <td> - </td> 
    <td></td> 
</tr> 
<tr> 
   <td>st_member</td> 
   <td>TINYINT(1)</td> 
    <td>NO</td> 
    <td> - </td> 
    <td></td> 
</tr> 
<tr> 
   <td>ds_lastip</td> 
   <td>VARCHAR(30)</td> 
    <td>SI</td> 
    <td> - </td> 
    <td></td> 
</tr> 
<tr> 
   <td>ds_comments</td> 
   <td>TEXT</td> 
    <td>SI</td> 
    <td> - </td> 
    <td></td> 
</tr> 
</table> 
</li> 
<li id="members_offices"> 
<h2>members_offices</h2> 
<p></p> 
<table> 
<tr> 
<th>CAMPO</th> 
<th>TIPO</th> 
<th>NULO</th> 
<th>EXTRA</th> 
<th>COMENTARIOS</th> 
</tr> 
<tr> 
   <td>idMember</td> 
   <td>INT(11)</td> 
    <td>NO</td> 
    <td> - </td> 
    <td></td> 
</tr> 
<tr> 
   <td>idCargo</td> 
   <td>INT(11)</td> 
    <td>NO</td> 
    <td> - </td> 
    <td></td> 
</tr> 
<tr> 
   <td>nr_order</td> 
   <td>INT(11)</td> 
    <td>NO</td> 
    <td> - </td> 
    <td></td> 
</tr> 
</table> 
</li> 
<li id="menu"> 
<h2>menu</h2> 
<p></p> 
<table> 
<tr> 
<th>CAMPO</th> 
<th>TIPO</th> 
<th>NULO</th> 
<th>EXTRA</th> 
<th>COMENTARIOS</th> 
</tr> 
<tr> 
   <td>idMenu</td> 
   <td>INT(11)</td> 
    <td>NO</td> 
    <td>AUTO_INCREMENT</td> 
    <td></td> 
</tr> 
<tr> 
   <td>ds_menu</td> 
   <td>VARCHAR(50)</td> 
    <td>NO</td> 
    <td> - </td> 
    <td></td> 
</tr> 
<tr> 
   <td>ds_controller</td> 
   <td>VARCHAR(100)</td> 
    <td>NO</td> 
    <td> - </td> 
    <td></td> 
</tr> 
<tr> 
   <td>ds_action</td> 
   <td>VARCHAR(100)</td> 
    <td>NO</td> 
    <td> - </td> 
    <td></td> 
</tr> 
<tr> 
   <td>st_menu</td> 
   <td>TINYINT(1)</td> 
    <td>NO</td> 
    <td> - </td> 
    <td></td> 
</tr> 
<tr> 
   <td>dt_created</td> 
   <td>DATETIME</td> 
    <td>NO</td> 
    <td> - </td> 
    <td></td> 
</tr> 
<tr> 
   <td>dt_updated</td> 
   <td>DATETIME</td> 
    <td>SI</td> 
    <td> - </td> 
    <td></td> 
</tr> 
<tr> 
   <td>idParent</td> 
   <td>INT(11)</td> 
    <td>NO</td> 
    <td> - </td> 
    <td></td> 
</tr> 
</table> 
</li> 
<li id="menu_profiles"> 
<h2>menu_profiles</h2> 
<p></p> 
<table> 
<tr> 
<th>CAMPO</th> 
<th>TIPO</th> 
<th>NULO</th> 
<th>EXTRA</th> 
<th>COMENTARIOS</th> 
</tr> 
<tr> 
   <td>idProfile</td> 
   <td>INT(11)</td> 
    <td>NO</td> 
    <td> - </td> 
    <td></td> 
</tr> 
<tr> 
   <td>idMenu</td> 
   <td>INT(11)</td> 
    <td>NO</td> 
    <td> - </td> 
    <td></td> 
</tr> 
</table> 
</li> 
<li id="midia"> 
<h2>midia</h2> 
<p></p> 
<table> 
<tr> 
<th>CAMPO</th> 
<th>TIPO</th> 
<th>NULO</th> 
<th>EXTRA</th> 
<th>COMENTARIOS</th> 
</tr> 
<tr> 
   <td>idMidia</td> 
   <td>INT(11)</td> 
    <td>NO</td> 
    <td>AUTO_INCREMENT</td> 
    <td></td> 
</tr> 
<tr> 
   <td>ds_midia</td> 
   <td>VARCHAR(100)</td> 
    <td>NO</td> 
    <td> - </td> 
    <td></td> 
</tr> 
<tr> 
   <td>st_midia</td> 
   <td>TINYINT(1)</td> 
    <td>NO</td> 
    <td> - </td> 
    <td></td> 
</tr> 
<tr> 
   <td>dt_insercao</td> 
   <td>DATETIME</td> 
    <td>NO</td> 
    <td> - </td> 
    <td></td> 
</tr> 
<tr> 
   <td>dt_atualizacao</td> 
   <td>DATETIME</td> 
    <td>SI</td> 
    <td> - </td> 
    <td></td> 
</tr> 
</table> 
</li> 
<li id="paises"> 
<h2>paises</h2> 
<p>Informações dos países.</p> 
<table> 
<tr> 
<th>CAMPO</th> 
<th>TIPO</th> 
<th>NULO</th> 
<th>EXTRA</th> 
<th>COMENTARIOS</th> 
</tr> 
<tr> 
   <td>idPais</td> 
   <td>INT(11)</td> 
    <td>NO</td> 
    <td>AUTO_INCREMENT</td> 
    <td>Chave Primária</td> 
</tr> 
<tr> 
   <td>ds_sigla</td> 
   <td>VARCHAR(5)</td> 
    <td>NO</td> 
    <td> - </td> 
    <td>Sigla</td> 
</tr> 
<tr> 
   <td>ds_pais</td> 
   <td>VARCHAR(120)</td> 
    <td>NO</td> 
    <td> - </td> 
    <td>País</td> 
</tr> 
<tr> 
   <td>ds_moeda</td> 
   <td>VARCHAR(45)</td> 
    <td>NO</td> 
    <td> - </td> 
    <td>Moeda</td> 
</tr> 
<tr> 
   <td>ds_prefixo</td> 
   <td>VARCHAR(5)</td> 
    <td>NO</td> 
    <td> - </td> 
    <td>Prefixo</td> 
</tr> 
<tr> 
   <td>ds_situacao</td> 
   <td>TINYINT(1)</td> 
    <td>NO</td> 
    <td> - </td> 
    <td>Situação</td> 
</tr> 
<tr> 
   <td>dt_insercao</td> 
   <td>DATETIME</td> 
    <td>NO</td> 
    <td> - </td> 
    <td>Data de Inserção</td> 
</tr> 
<tr> 
   <td>dt_atualizacao</td> 
   <td>DATETIME</td> 
    <td>SI</td> 
    <td> - </td> 
    <td>Data de Atualização</td> 
</tr> 
</table> 
</li> 
<li id="profiles"> 
<h2>profiles</h2> 
<p></p> 
<table> 
<tr> 
<th>CAMPO</th> 
<th>TIPO</th> 
<th>NULO</th> 
<th>EXTRA</th> 
<th>COMENTARIOS</th> 
</tr> 
<tr> 
   <td>idProfile</td> 
   <td>INT(11)</td> 
    <td>NO</td> 
    <td>AUTO_INCREMENT</td> 
    <td>Chave primária da tabela
</td> 
</tr> 
<tr> 
   <td>ds_profile</td> 
   <td>VARCHAR(100)</td> 
    <td>NO</td> 
    <td> - </td> 
    <td>descrição do perfil.</td> 
</tr> 
<tr> 
   <td>st_profile</td> 
   <td>TINYINT(1)</td> 
    <td>NO</td> 
    <td> - </td> 
    <td>Situação do perfil, sendo 0: inativo/bloqueado ou 1:ativo.</td> 
</tr> 
<tr> 
   <td>dt_created</td> 
   <td>DATETIME</td> 
    <td>SI</td> 
    <td> - </td> 
    <td>data de criação do perfil</td> 
</tr> 
<tr> 
   <td>dt_updated</td> 
   <td>DATETIME</td> 
    <td>SI</td> 
    <td> - </td> 
    <td>data de atualização do perfil</td> 
</tr> 
</table> 
</li> 
<li id="profissoes"> 
<h2>profissoes</h2> 
<p></p> 
<table> 
<tr> 
<th>CAMPO</th> 
<th>TIPO</th> 
<th>NULO</th> 
<th>EXTRA</th> 
<th>COMENTARIOS</th> 
</tr> 
<tr> 
   <td>idProfissao</td> 
   <td>INT(11)</td> 
    <td>NO</td> 
    <td>AUTO_INCREMENT</td> 
    <td></td> 
</tr> 
<tr> 
   <td>sgl_profissao</td> 
   <td>VARCHAR(5)</td> 
    <td>SI</td> 
    <td> - </td> 
    <td></td> 
</tr> 
<tr> 
   <td>ds_profissao</td> 
   <td>VARCHAR(100)</td> 
    <td>NO</td> 
    <td> - </td> 
    <td></td> 
</tr> 
<tr> 
   <td>st_profissao</td> 
   <td>TINYINT(1)</td> 
    <td>NO</td> 
    <td> - </td> 
    <td></td> 
</tr> 
<tr> 
   <td>dt_insercao</td> 
   <td>DATETIME</td> 
    <td>NO</td> 
    <td> - </td> 
    <td></td> 
</tr> 
<tr> 
   <td>dt_atualizacao</td> 
   <td>DATETIME</td> 
    <td>SI</td> 
    <td> - </td> 
    <td></td> 
</tr> 
</table> 
</li> 
<li id="turmas"> 
<h2>turmas</h2> 
<p></p> 
<table> 
<tr> 
<th>CAMPO</th> 
<th>TIPO</th> 
<th>NULO</th> 
<th>EXTRA</th> 
<th>COMENTARIOS</th> 
</tr> 
<tr> 
   <td>idTurma</td> 
   <td>INT(11)</td> 
    <td>NO</td> 
    <td>AUTO_INCREMENT</td> 
    <td></td> 
</tr> 
<tr> 
   <td>sgl_turma</td> 
   <td>VARCHAR(10)</td> 
    <td>NO</td> 
    <td> - </td> 
    <td></td> 
</tr> 
<tr> 
   <td>ds_turma</td> 
   <td>VARCHAR(120)</td> 
    <td>NO</td> 
    <td> - </td> 
    <td></td> 
</tr> 
<tr> 
   <td>dt_inicio_aula</td> 
   <td>DATE</td> 
    <td>NO</td> 
    <td> - </td> 
    <td></td> 
</tr> 
<tr> 
   <td>dt_termino_previsao</td> 
   <td>VARCHAR(45)</td> 
    <td>NO</td> 
    <td> - </td> 
    <td></td> 
</tr> 
<tr> 
   <td>nr_qtd_max</td> 
   <td>INT(11)</td> 
    <td>NO</td> 
    <td> - </td> 
    <td></td> 
</tr> 
<tr> 
   <td>nr_qtd_min</td> 
   <td>INT(11)</td> 
    <td>NO</td> 
    <td> - </td> 
    <td></td> 
</tr> 
<tr> 
   <td>nr_qtd_aulas_semanais</td> 
   <td>INT(11)</td> 
    <td>NO</td> 
    <td> - </td> 
    <td></td> 
</tr> 
<tr> 
   <td>idSala</td> 
   <td>INT(11)</td> 
    <td>NO</td> 
    <td> - </td> 
    <td></td> 
</tr> 
<tr> 
   <td>ds_tempo_aula</td> 
   <td>TIME</td> 
    <td>NO</td> 
    <td> - </td> 
    <td></td> 
</tr> 
<tr> 
   <td>st_turma</td> 
   <td>TINYINT(1)</td> 
    <td>NO</td> 
    <td> - </td> 
    <td></td> 
</tr> 
<tr> 
   <td>dt_insercao</td> 
   <td>DATETIME</td> 
    <td>NO</td> 
    <td> - </td> 
    <td></td> 
</tr> 
<tr> 
   <td>dt_atualizacao</td> 
   <td>DATETIME</td> 
    <td>SI</td> 
    <td> - </td> 
    <td></td> 
</tr> 
<tr> 
   <td>ds_aula_dias_semana</td> 
   <td>VARCHAR(100)</td> 
    <td>SI</td> 
    <td> - </td> 
    <td></td> 
</tr> 
</table> 
</li> 
<li id="unidade"> 
<h2>unidade</h2> 
<p>Informações da Unidade de Ensino</p> 
<table> 
<tr> 
<th>CAMPO</th> 
<th>TIPO</th> 
<th>NULO</th> 
<th>EXTRA</th> 
<th>COMENTARIOS</th> 
</tr> 
<tr> 
   <td>idUnidade</td> 
   <td>INT(11)</td> 
    <td>NO</td> 
    <td>AUTO_INCREMENT</td> 
    <td></td> 
</tr> 
<tr> 
   <td>sgl_unidade</td> 
   <td>VARCHAR(5)</td> 
    <td>SI</td> 
    <td> - </td> 
    <td></td> 
</tr> 
<tr> 
   <td>ds_unidade</td> 
   <td>VARCHAR(120)</td> 
    <td>NO</td> 
    <td> - </td> 
    <td></td> 
</tr> 
<tr> 
   <td>ds_razao_social</td> 
   <td>VARCHAR(200)</td> 
    <td>NO</td> 
    <td> - </td> 
    <td></td> 
</tr> 
<tr> 
   <td>ds_cnpj</td> 
   <td>VARCHAR(18)</td> 
    <td>NO</td> 
    <td> - </td> 
    <td></td> 
</tr> 
<tr> 
   <td>ds_cep</td> 
   <td>INT(11)</td> 
    <td>NO</td> 
    <td> - </td> 
    <td></td> 
</tr> 
<tr> 
   <td>ds_phone</td> 
   <td>VARCHAR(15)</td> 
    <td>NO</td> 
    <td> - </td> 
    <td></td> 
</tr> 
<tr> 
   <td>ds_site</td> 
   <td>VARCHAR(200)</td> 
    <td>SI</td> 
    <td> - </td> 
    <td></td> 
</tr> 
<tr> 
   <td>st_unidade</td> 
   <td>TINYINT(1)</td> 
    <td>NO</td> 
    <td> - </td> 
    <td></td> 
</tr> 
<tr> 
   <td>ds_logotipo</td> 
   <td>VARCHAR(200)</td> 
    <td>SI</td> 
    <td> - </td> 
    <td></td> 
</tr> 
<tr> 
   <td>idDiretor</td> 
   <td>INT(11)</td> 
    <td>NO</td> 
    <td> - </td> 
    <td></td> 
</tr> 
</table> 
</li> 
<li id="unidade_curso"> 
<h2>unidade_curso</h2> 
<p></p> 
<table> 
<tr> 
<th>CAMPO</th> 
<th>TIPO</th> 
<th>NULO</th> 
<th>EXTRA</th> 
<th>COMENTARIOS</th> 
</tr> 
<tr> 
   <td>idUnidade</td> 
   <td>INT(11)</td> 
    <td>NO</td> 
    <td> - </td> 
    <td></td> 
</tr> 
<tr> 
   <td>idCurso</td> 
   <td>INT(11)</td> 
    <td>NO</td> 
    <td> - </td> 
    <td></td> 
</tr> 
</table> 
</li> 
<li id="offices"> 
<h2>offices</h2> 
<p></p> 
<table> 
<tr> 
<th>CAMPO</th> 
<th>TIPO</th> 
<th>NULO</th> 
<th>EXTRA</th> 
<th>COMENTARIOS</th> 
</tr> 
<tr> 
   <td>idOffice</td> 
   <td>INT(11)</td> 
    <td>SI</td> 
    <td> - </td> 
    <td></td> 
</tr> 
</table> 
</li> 
<li id="Disciplinas"> 
<h2>Disciplinas</h2> 
<p></p> 
<table> 
<tr> 
<th>CAMPO</th> 
<th>TIPO</th> 
<th>NULO</th> 
<th>EXTRA</th> 
<th>COMENTARIOS</th> 
</tr> 
<tr> 
   <td>idDisciplina</td> 
   <td>INT(11)</td> 
    <td>NO</td> 
    <td>AUTO_INCREMENT</td> 
    <td></td> 
</tr> 
<tr> 
   <td>sgl_disciplina</td> 
   <td>CHAR(5)</td> 
    <td>NO</td> 
    <td> - </td> 
    <td></td> 
</tr> 
<tr> 
   <td>ds_disciplina</td> 
   <td>VARCHAR(100)</td> 
    <td>NO</td> 
    <td> - </td> 
    <td></td> 
</tr> 
<tr> 
   <td>ds_carga_horaria</td> 
   <td>TIME</td> 
    <td>NO</td> 
    <td> - </td> 
    <td></td> 
</tr> 
<tr> 
   <td>idTipoDisciplina</td> 
   <td>INT(11)</td> 
    <td>NO</td> 
    <td> - </td> 
    <td></td> 
</tr> 
<tr> 
   <td>ds_ementa</td> 
   <td>TEXT</td> 
    <td>NO</td> 
    <td> - </td> 
    <td></td> 
</tr> 
<tr> 
   <td>st_disciplina</td> 
   <td>TINYINT(1)</td> 
    <td>NO</td> 
    <td> - </td> 
    <td></td> 
</tr> 
<tr> 
   <td>dt_insercao</td> 
   <td>DATETIME</td> 
    <td>NO</td> 
    <td> - </td> 
    <td></td> 
</tr> 
<tr> 
   <td>dt_update</td> 
   <td>DATETIME</td> 
    <td>SI</td> 
    <td> - </td> 
    <td></td> 
</tr> 
<tr> 
   <td>ds_prerequisito</td> 
   <td>TEXT</td> 
    <td>SI</td> 
    <td> - </td> 
    <td></td> 
</tr> 
</table> 
</li> 
<li id="Departamentos"> 
<h2>Departamentos</h2> 
<p></p> 
<table> 
<tr> 
<th>CAMPO</th> 
<th>TIPO</th> 
<th>NULO</th> 
<th>EXTRA</th> 
<th>COMENTARIOS</th> 
</tr> 
<tr> 
   <td>idDepartamento</td> 
   <td>INT</td> 
    <td>NO</td> 
    <td> - </td> 
    <td></td> 
</tr> 
<tr> 
   <td>ds_departamento</td> 
   <td>VARCHAR(100)</td> 
    <td>NO</td> 
    <td> - </td> 
    <td></td> 
</tr> 
<tr> 
   <td>dt_insercao</td> 
   <td>DATETIME</td> 
    <td>NO</td> 
    <td> - </td> 
    <td></td> 
</tr> 
<tr> 
   <td>dt_atualizacao</td> 
   <td>DATETIME</td> 
    <td>SI</td> 
    <td> - </td> 
    <td></td> 
</tr> 
</table> 
</li> 
<li id="disciplina_curso"> 
<h2>disciplina_curso</h2> 
<p></p> 
<table> 
<tr> 
<th>CAMPO</th> 
<th>TIPO</th> 
<th>NULO</th> 
<th>EXTRA</th> 
<th>COMENTARIOS</th> 
</tr> 
<tr> 
   <td>idDisciplina</td> 
   <td>INT(11)</td> 
    <td>NO</td> 
    <td> - </td> 
    <td></td> 
</tr> 
<tr> 
   <td>idCurso</td> 
   <td>INT(11)</td> 
    <td>NO</td> 
    <td> - </td> 
    <td></td> 
</tr> 
</table> 
</li> 
<li id="Cargos"> 
<h2>Cargos</h2> 
<p></p> 
<table> 
<tr> 
<th>CAMPO</th> 
<th>TIPO</th> 
<th>NULO</th> 
<th>EXTRA</th> 
<th>COMENTARIOS</th> 
</tr> 
<tr> 
   <td>idCargo</td> 
   <td>INT(11)</td> 
    <td>NO</td> 
    <td>AUTO_INCREMENT</td> 
    <td></td> 
</tr> 
<tr> 
   <td>ds_cargo</td> 
   <td>VARCHAR(100)</td> 
    <td>NO</td> 
    <td> - </td> 
    <td></td> 
</tr> 
<tr> 
   <td>st_cargo</td> 
   <td>TINYINT(1)</td> 
    <td>NO</td> 
    <td> - </td> 
    <td></td> 
</tr> 
<tr> 
   <td>dt_insercao</td> 
   <td>DATETIME</td> 
    <td>NO</td> 
    <td> - </td> 
    <td></td> 
</tr> 
<tr> 
   <td>dt_atualizacao</td> 
   <td>DATETIME</td> 
    <td>SI</td> 
    <td> - </td> 
    <td></td> 
</tr> 
</table> 
</li> 
<li id="disciplina_member"> 
<h2>disciplina_member</h2> 
<p></p> 
<table> 
<tr> 
<th>CAMPO</th> 
<th>TIPO</th> 
<th>NULO</th> 
<th>EXTRA</th> 
<th>COMENTARIOS</th> 
</tr> 
<tr> 
   <td>idDisciplina</td> 
   <td>INT(11)</td> 
    <td>NO</td> 
    <td> - </td> 
    <td></td> 
</tr> 
<tr> 
   <td>idMember</td> 
   <td>INT(11)</td> 
    <td>NO</td> 
    <td> - </td> 
    <td></td> 
</tr> 
</table> 
</li> 
</ol> 
</body> 
</html>